<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/functions" prefix="fn" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt" %>

<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>Featured Listings</title>
        
        <link rel="stylesheet" href="${model.props.appPath}/css/jquery/lightness-jquery-ui.css">
        <link rel="stylesheet" href="${model.props.appPath}/css/jquery/jquery.datetimepicker.css">
        <style>
            a {color:#404042;text-decoration:none;}      /* unvisited link */
            a:visited {color:#404042;}  /* visited link */
            a:hover {color:#404042;}  /* mouse over link */
            a:active {color:#404042;}  /* selected link */
            @font-face
            {
            font-family: avant;
            src: url('${model.props.appPath}/fonts/avangmi-webfont.ttf');
            }
            
        </style>
        
        <script src="//code.jquery.com/jquery-1.9.1.js"></script>
        <script src="//code.jquery.com/ui/1.10.4/jquery-ui.js"></script>           
        <script src="${model.props.appPath}/js/jquery/jquery.datetimepicker.js"></script>   
        <script type="text/javascript">            
            $(document).ready(function() {
                $("#table-makati-1 tr:even").css("background-color", "#f1f1f1"); 
                $("#table-makati-2 tr:even").css("background-color", "#f1f1f1"); 
                $( "#start-date" ).datetimepicker();
                $( "#end-date" ).datetimepicker();
            });
        </script>      
    </head>


    <body style="text-align: center; background-color: #FAFAFA; color: #404042; font-family: avant, Century Gothic, Calibri, Verdana; padding: 0px; margin: 0px;">                

        <div style="margin-top: 0px; background-color: white;">

            <%@include file="header.jsp" %>

            <div style="width: 100%; text-align: left; font-family: avant, Century Gothic, Calibri, Verdana; color: #404042; background-color: white; background: url('${model.props.appPath}/img/content-bg-short.jpg'); background-repeat: repeat-x; display: block; position: relative; top: -2px;">

                <div style="width: 1220px; margin-top: 10px; margin: 0 auto;">

                    <br>
                    
                    <h1>Featured Listings Management</h1>
                    <hr>
                    <br>
                    
                    <form>
                        <table cellpadding="5" cellspacing="5" style="padding: 10px; ">
                            <tr>
                                <th>Listing ID</th>
                                <th>City</th>                
                                <th>Term Type</th>
                                <th>Start Date</th>
                                <th>End Date</th>
                            </tr>
                            <tr>                                
                                <td><input type="text" name="listingID" style="font-family: avant; padding: 5px; width: 200px;"/></td>                                
                                <td>
                                    <select id="listing-city" name="city" style="width:200px; padding: 5px;">
                                        <option value="" >--- Choose One ---</option>
                                        <option value="Makati" selected>Makati</option>
                                        <option value="Taguig">Taguig</option>
                                        <option value="Mandaluyong">Mandaluyong</option>
                                        <option value="Pasig">Pasig</option>
                                        <option value="Quezon City">Quezon City</option>
                                        <option value="Manila">Manila</option>
                                        <option value="Pasay">Pasay</option>
                                        <option value="Paranaque">Paranaque</option>
                                        <option value="Muntinlupa">Muntinlupa</option>
                                        <option value="Las Pinas">Las Pinas</option>
                                        <option value="San Juan">San Juan</option>
                                        <option value="Cebu">Cebu</option>
                                        <option value="Davao">Davao</option>
                                    </select>
                                </td>                
                                <td>
                                    <select id="listing-termType" name="termType" style="width: 200px; padding: 5px;">
                                        <option value="">--- Choose One ---</option>
                                        <option value="1" selected >Long Term</option>
                                        <option value="2">Short Term</option>
                                    </select>
                                </td>
                                <td>
                                    <input id="start-date" type="text" name="startDate" style="font-family: avant; padding: 5px; width: 200px;"/>
                                </td>
                                <td>
                                    <input id="end-date" type="text" name="endDate" style="font-family: avant; padding: 5px; width: 200px;"/>
                                </td>
                            </tr>
                            <tr>
                                
                                <td colspan="5" align="right">
                                    <input type="hidden" name="a" value="9023" />
                                    <input type="submit" style="padding: 5px;"value="  Add Featured Listing  "/>
                                </td>
                            </tr>
                        </table>
                    </form>
                    
                    <br>
                    <h2>Featured in Makati</h2>
                    <hr style="padding: 5px; background-color: #aaa;">
                    
                    <fieldset>
                        <legend>Long Term</legend>
                        <table id="table-makati-1" cellpadding="5" cellspacing="5" style="padding: 5px; width: 100%; border-collapse: collapse;">                            
                            <tr>
                                <th>ID</th>
                                <th>Listing ID</th>
                                <th>Start</th>
                                <th>UTC</th>
                                <th>GMT+8</th>
                                <th>End</th>
                                <th>UTC</th>
                                <th>GMT+8</th>
                                <th></th>
                            </tr>
                            <c:forEach items="${model.featuredsMakati1}" var="featured">
                            <tr>
                                <td style="width: 150px;">${featured.id}</td>
                                <td style="width: 150px;">${featured.listingID}</td>
                                <td><fmt:formatDate value="${featured.startDate}" pattern="yyyy/MM/dd HH:mm" /></td>
                                <td>${featured.strStartDate}</td>
                                <td>${featured.strStartDateManila}</td>
                                <td><fmt:formatDate value="${featured.endDate}" pattern="yyyy/MM/dd HH:mm" /></td>
                                <td>${featured.strEndDate}</td>
                                <td>${featured.strEndDateManila}</td>
                                <td><a href="${model.props.appPath}/featured.htm?a=9025&id=${featured.id}"><input type="button" value=" delete "/></a></td>
                            </tr>
                            <tr><td colspan="9"></td></tr>
                            </c:forEach>
                        </table>
                    </fieldset>
                    
                    <br>
                    <br>
                    
                    <fieldset>
                        <legend>Short Term</legend>
                        <table id="table-makati-2" cellpadding="5" cellspacing="5" style="padding: 5px; width: 100%; border-collapse: collapse;">                            
                            <tr>
                                <th>ID</th>
                                <th>Listing ID</th>
                                <th>Start</th>
                                <th>UTC</th>
                                <th>GMT+8</th>
                                <th>End</th>
                                <th>UTC</th>
                                <th>GMT+8</th>
                                <th></th>
                            </tr>
                            <c:forEach items="${model.featuredsMakati2}" var="featured">
                            <tr>
                                <td style="width: 150px;">${featured.id}</td>
                                <td style="width: 150px;">${featured.listingID}</td>
                                <td><fmt:formatDate value="${featured.startDate}" pattern="yyyy/MM/dd HH:mm" /></td>
                                <td>${featured.strStartDate}</td>
                                <td>${featured.strStartDateManila}</td>
                                <td><fmt:formatDate value="${featured.endDate}" pattern="yyyy/MM/dd HH:mm" /></td>
                                <td>${featured.strEndDate}</td>
                                <td>${featured.strEndDateManila}</td>
                                <td><a href="${model.props.appPath}/featured.htm?a=9025&id=${featured.id}"><input type="button" value=" delete "/></a></td>
                            </tr>
                            <tr><td colspan="9"></td></tr>
                            </c:forEach>
                        </table>
                    </fieldset>
                    
                    <br><br><br><br>
                    
                    <h2>Featured in Taguig</h2>
                    <hr style="padding: 5px; background-color: #aaa;">
                    
                    <fieldset>
                        <legend>Long Term</legend>
                        <table id="table-makati-1" cellpadding="5" cellspacing="5" style="padding: 5px; width: 100%; border-collapse: collapse;">                            
                            <tr>
                                <th>ID</th>
                                <th>Listing ID</th>
                                <th>Start</th>
                                <th>UTC</th>
                                <th>GMT+8</th>
                                <th>End</th>
                                <th>UTC</th>
                                <th>GMT+8</th>
                                <th></th>
                            </tr>
                            <c:forEach items="${model.featuredsTaguig1}" var="featured">
                            <tr>
                                <td style="width: 150px;">${featured.id}</td>
                                <td style="width: 150px;">${featured.listingID}</td>
                                <td><fmt:formatDate value="${featured.startDate}" pattern="yyyy/MM/dd HH:mm" /></td>
                                <td>${featured.strStartDate}</td>
                                <td>${featured.strStartDateManila}</td>
                                <td><fmt:formatDate value="${featured.endDate}" pattern="yyyy/MM/dd HH:mm" /></td>
                                <td>${featured.strEndDate}</td>
                                <td>${featured.strEndDateManila}</td>
                                <td><a href="${model.props.appPath}/featured.htm?a=9025&id=${featured.id}"><input type="button" value=" delete "/></a></td>
                            </tr>
                            <tr><td colspan="9"></td></tr>
                            </c:forEach>
                        </table>
                    </fieldset>
                    
                    <br>
                    <br>
                    
                    <fieldset>
                        <legend>Short Term</legend>
                        <table id="table-makati-2" cellpadding="5" cellspacing="5" style="padding: 5px; width: 100%; border-collapse: collapse;">                            
                            <tr>
                                <th>ID</th>
                                <th>Listing ID</th>
                                <th>Start</th>
                                <th>UTC</th>
                                <th>GMT+8</th>
                                <th>End</th>
                                <th>UTC</th>
                                <th>GMT+8</th>
                                <th></th>
                            </tr>
                            <c:forEach items="${model.featuredsTaguig2}" var="featured">
                            <tr>
                                <td style="width: 150px;">${featured.id}</td>
                                <td style="width: 150px;">${featured.listingID}</td>
                                <td><fmt:formatDate value="${featured.startDate}" pattern="yyyy/MM/dd HH:mm" /></td>
                                <td>${featured.strStartDate}</td>
                                <td>${featured.strStartDateManila}</td>
                                <td><fmt:formatDate value="${featured.endDate}" pattern="yyyy/MM/dd HH:mm" /></td>
                                <td>${featured.strEndDate}</td>
                                <td>${featured.strEndDateManila}</td>
                                <td><a href="${model.props.appPath}/featured.htm?a=9025&id=${featured.id}"><input type="button" value=" delete "/></a></td>
                            </tr>
                            <tr><td colspan="9"></td></tr>
                            </c:forEach>
                        </table>
                    </fieldset>
                    
                    <br><br><br><br>
                    
                    <br>
                    <h2>Featured in Quezon City</h2>
                    <hr style="padding: 5px; background-color: #aaa;">
                    
                    <fieldset>
                        <legend>Long Term</legend>
                        <table id="table-makati-1" cellpadding="5" cellspacing="5" style="padding: 5px; width: 100%; border-collapse: collapse;">                            
                            <tr>
                                <th>ID</th>
                                <th>Listing ID</th>
                                <th>Start</th>
                                <th>UTC</th>
                                <th>GMT+8</th>
                                <th>End</th>
                                <th>UTC</th>
                                <th>GMT+8</th>
                                <th></th>
                            </tr>
                            <c:forEach items="${model.featuredsQuezonCity1}" var="featured">
                            <tr>
                                <td style="width: 150px;">${featured.id}</td>
                                <td style="width: 150px;">${featured.listingID}</td>
                                <td><fmt:formatDate value="${featured.startDate}" pattern="yyyy/MM/dd HH:mm" /></td>
                                <td>${featured.strStartDate}</td>
                                <td>${featured.strStartDateManila}</td>
                                <td><fmt:formatDate value="${featured.endDate}" pattern="yyyy/MM/dd HH:mm" /></td>
                                <td>${featured.strEndDate}</td>
                                <td>${featured.strEndDateManila}</td>
                                <td><a href="${model.props.appPath}/featured.htm?a=9025&id=${featured.id}"><input type="button" value=" delete "/></a></td>
                            </tr>
                            <tr><td colspan="9"></td></tr>
                            </c:forEach>
                        </table>
                    </fieldset>
                    
                    <br>
                    <br>
                    
                    <fieldset>
                        <legend>Short Term</legend>
                        <table id="table-makati-2" cellpadding="5" cellspacing="5" style="padding: 5px; width: 100%; border-collapse: collapse;">                            
                            <tr>
                                <th>ID</th>
                                <th>Listing ID</th>
                                <th>Start</th>
                                <th>UTC</th>
                                <th>GMT+8</th>
                                <th>End</th>
                                <th>UTC</th>
                                <th>GMT+8</th>
                                <th></th>
                            </tr>
                            <c:forEach items="${model.featuredsQuezonCity2}" var="featured">
                            <tr>
                                <td style="width: 150px;">${featured.id}</td>
                                <td style="width: 150px;">${featured.listingID}</td>
                                <td><fmt:formatDate value="${featured.startDate}" pattern="yyyy/MM/dd HH:mm" /></td>
                                <td>${featured.strStartDate}</td>
                                <td>${featured.strStartDateManila}</td>
                                <td><fmt:formatDate value="${featured.endDate}" pattern="yyyy/MM/dd HH:mm" /></td>
                                <td>${featured.strEndDate}</td>
                                <td>${featured.strEndDateManila}</td>
                                <td><a href="${model.props.appPath}/featured.htm?a=9025&id=${featured.id}"><input type="button" value=" delete "/></a></td>
                            </tr>
                            <tr><td colspan="9"></td></tr>
                            </c:forEach>
                        </table>
                    </fieldset>
                    
                    <br><br><br><br>
                    
                    <h2>Featured in Mandaluyong</h2>
                    <hr style="padding: 5px; background-color: #aaa;">
                                        
                    <fieldset>
                        <legend>Long Term</legend>
                        <table id="table-makati-1" cellpadding="5" cellspacing="5" style="padding: 5px; width: 100%; border-collapse: collapse;">                            
                            <tr>
                                <th>ID</th>
                                <th>Listing ID</th>
                                <th>Start</th>
                                <th>UTC</th>
                                <th>GMT+8</th>
                                <th>End</th>
                                <th>UTC</th>
                                <th>GMT+8</th>
                                <th></th>
                            </tr>
                            <c:forEach items="${model.featuredsMandaluyong1}" var="featured">
                            <tr>
                                <td style="width: 150px;">${featured.id}</td>
                                <td style="width: 150px;">${featured.listingID}</td>
                                <td><fmt:formatDate value="${featured.startDate}" pattern="yyyy/MM/dd HH:mm" /></td>
                                <td>${featured.strStartDate}</td>
                                <td>${featured.strStartDateManila}</td>
                                <td><fmt:formatDate value="${featured.endDate}" pattern="yyyy/MM/dd HH:mm" /></td>
                                <td>${featured.strEndDate}</td>
                                <td>${featured.strEndDateManila}</td>
                                <td><a href="${model.props.appPath}/featured.htm?a=9025&id=${featured.id}"><input type="button" value=" delete "/></a></td>
                            </tr>
                            <tr><td colspan="9"></td></tr>
                            </c:forEach>
                        </table>
                    </fieldset>
                    
                    <br>
                    <br>
                    
                    <fieldset>
                        <legend>Short Term</legend>
                        <table id="table-makati-2" cellpadding="5" cellspacing="5" style="padding: 5px; width: 100%; border-collapse: collapse;">                            
                            <tr>
                                <th>ID</th>
                                <th>Listing ID</th>
                                <th>Start</th>
                                <th>UTC</th>
                                <th>GMT+8</th>
                                <th>End</th>
                                <th>UTC</th>
                                <th>GMT+8</th>
                                <th></th>
                            </tr>
                            <c:forEach items="${model.featuredsMandaluyong2}" var="featured">
                            <tr>
                                <td style="width: 150px;">${featured.id}</td>
                                <td style="width: 150px;">${featured.listingID}</td>
                                <td><fmt:formatDate value="${featured.startDate}" pattern="yyyy/MM/dd HH:mm" /></td>
                                <td>${featured.strStartDate}</td>
                                <td>${featured.strStartDateManila}</td>
                                <td><fmt:formatDate value="${featured.endDate}" pattern="yyyy/MM/dd HH:mm" /></td>
                                <td>${featured.strEndDate}</td>
                                <td>${featured.strEndDateManila}</td>
                                <td><a href="${model.props.appPath}/featured.htm?a=9025&id=${featured.id}"><input type="button" value=" delete "/></a></td>
                            </tr>
                            <tr><td colspan="9"></td></tr>
                            </c:forEach>
                        </table>
                    </fieldset>                    
                    
                    <br><br><br><br>
                    
                    <h2>Featured in Pasig</h2>
                    <hr style="padding: 5px; background-color: #aaa;">
                                      
                    <fieldset>
                        <legend>Long Term</legend>
                        <table id="table-makati-1" cellpadding="5" cellspacing="5" style="padding: 5px; width: 100%; border-collapse: collapse;">                            
                            <tr>
                                <th>ID</th>
                                <th>Listing ID</th>
                                <th>Start</th>
                                <th>UTC</th>
                                <th>GMT+8</th>
                                <th>End</th>
                                <th>UTC</th>
                                <th>GMT+8</th>
                                <th></th>
                            </tr>
                            <c:forEach items="${model.featuredsPasig1}" var="featured">
                            <tr>
                                <td style="width: 150px;">${featured.id}</td>
                                <td style="width: 150px;">${featured.listingID}</td>
                                <td><fmt:formatDate value="${featured.startDate}" pattern="yyyy/MM/dd HH:mm" /></td>
                                <td>${featured.strStartDate}</td>
                                <td>${featured.strStartDateManila}</td>
                                <td><fmt:formatDate value="${featured.endDate}" pattern="yyyy/MM/dd HH:mm" /></td>
                                <td>${featured.strEndDate}</td>
                                <td>${featured.strEndDateManila}</td>
                                <td><a href="${model.props.appPath}/featured.htm?a=9025&id=${featured.id}"><input type="button" value=" delete "/></a></td>
                            </tr>
                            <tr><td colspan="9"></td></tr>
                            </c:forEach>
                        </table>
                    </fieldset>
                    
                    <br>
                    <br>
                    
                    <fieldset>
                        <legend>Short Term</legend>
                        <table id="table-makati-2" cellpadding="5" cellspacing="5" style="padding: 5px; width: 100%; border-collapse: collapse;">                            
                            <tr>
                                <th>ID</th>
                                <th>Listing ID</th>
                                <th>Start</th>
                                <th>UTC</th>
                                <th>GMT+8</th>
                                <th>End</th>
                                <th>UTC</th>
                                <th>GMT+8</th>
                                <th></th>
                            </tr>
                            <c:forEach items="${model.featuredsPasig2}" var="featured">
                            <tr>
                                <td style="width: 150px;">${featured.id}</td>
                                <td style="width: 150px;">${featured.listingID}</td>
                                <td><fmt:formatDate value="${featured.startDate}" pattern="yyyy/MM/dd HH:mm" /></td>
                                <td>${featured.strStartDate}</td>
                                <td>${featured.strStartDateManila}</td>
                                <td><fmt:formatDate value="${featured.endDate}" pattern="yyyy/MM/dd HH:mm" /></td>
                                <td>${featured.strEndDate}</td>
                                <td>${featured.strEndDateManila}</td>
                                <td><a href="${model.props.appPath}/featured.htm?a=9025&id=${featured.id}"><input type="button" value=" delete "/></a></td>
                            </tr>
                            <tr><td colspan="9"></td></tr>
                            </c:forEach>
                        </table>
                    </fieldset>
                    
                    <br><br><br><br>
                    
                    <h2>Featured in Pasay</h2>
                    <hr style="padding: 5px; background-color: #aaa;">
                    
                    <fieldset>
                        <legend>Long Term</legend>
                        <table id="table-makati-1" cellpadding="5" cellspacing="5" style="padding: 5px; width: 100%; border-collapse: collapse;">                            
                            <tr>
                                <th>ID</th>
                                <th>Listing ID</th>
                                <th>Start</th>
                                <th>UTC</th>
                                <th>GMT+8</th>
                                <th>End</th>
                                <th>UTC</th>
                                <th>GMT+8</th>
                                <th></th>
                            </tr>
                            <c:forEach items="${model.featuredsPasay1}" var="featured">
                            <tr>
                                <td style="width: 150px;">${featured.id}</td>
                                <td style="width: 150px;">${featured.listingID}</td>
                                <td><fmt:formatDate value="${featured.startDate}" pattern="yyyy/MM/dd HH:mm" /></td>
                                <td>${featured.strStartDate}</td>
                                <td>${featured.strStartDateManila}</td>
                                <td><fmt:formatDate value="${featured.endDate}" pattern="yyyy/MM/dd HH:mm" /></td>
                                <td>${featured.strEndDate}</td>
                                <td>${featured.strEndDateManila}</td>
                                <td><a href="${model.props.appPath}/featured.htm?a=9025&id=${featured.id}"><input type="button" value=" delete "/></a></td>
                            </tr>
                            <tr><td colspan="9"></td></tr>
                            </c:forEach>
                        </table>
                    </fieldset>
                    
                    <br>
                    <br>
                    
                    <fieldset>
                        <legend>Short Term</legend>
                        <table id="table-makati-2" cellpadding="5" cellspacing="5" style="padding: 5px; width: 100%; border-collapse: collapse;">                            
                            <tr>
                                <th>ID</th>
                                <th>Listing ID</th>
                                <th>Start</th>
                                <th>UTC</th>
                                <th>GMT+8</th>
                                <th>End</th>
                                <th>UTC</th>
                                <th>GMT+8</th>
                                <th></th>
                            </tr>
                            <c:forEach items="${model.featuredsPasay2}" var="featured">
                            <tr>
                                <td style="width: 150px;">${featured.id}</td>
                                <td style="width: 150px;">${featured.listingID}</td>
                                <td><fmt:formatDate value="${featured.startDate}" pattern="yyyy/MM/dd HH:mm" /></td>
                                <td>${featured.strStartDate}</td>
                                <td>${featured.strStartDateManila}</td>
                                <td><fmt:formatDate value="${featured.endDate}" pattern="yyyy/MM/dd HH:mm" /></td>
                                <td>${featured.strEndDate}</td>
                                <td>${featured.strEndDateManila}</td>
                                <td><a href="${model.props.appPath}/featured.htm?a=9025&id=${featured.id}"><input type="button" value=" delete "/></a></td>
                            </tr>
                            <tr><td colspan="9"></td></tr>
                            </c:forEach>
                        </table>
                    </fieldset>
                    
                    <br><br><br><br>
                    
                    <h2>Featured in Manila</h2>
                    <hr style="padding: 5px; background-color: #aaa;">
                    
                    <fieldset>
                        <legend>Long Term</legend>
                        <table id="table-makati-1" cellpadding="5" cellspacing="5" style="padding: 5px; width: 100%; border-collapse: collapse;">                            
                            <tr>
                                <th>ID</th>
                                <th>Listing ID</th>
                                <th>Start</th>
                                <th>UTC</th>
                                <th>GMT+8</th>
                                <th>End</th>
                                <th>UTC</th>
                                <th>GMT+8</th>
                                <th></th>
                            </tr>
                            <c:forEach items="${model.featuredsManila1}" var="featured">
                            <tr>
                                <td style="width: 150px;">${featured.id}</td>
                                <td style="width: 150px;">${featured.listingID}</td>
                                <td><fmt:formatDate value="${featured.startDate}" pattern="yyyy/MM/dd HH:mm" /></td>
                                <td>${featured.strStartDate}</td>
                                <td>${featured.strStartDateManila}</td>
                                <td><fmt:formatDate value="${featured.endDate}" pattern="yyyy/MM/dd HH:mm" /></td>
                                <td>${featured.strEndDate}</td>
                                <td>${featured.strEndDateManila}</td>
                                <td><a href="${model.props.appPath}/featured.htm?a=9025&id=${featured.id}"><input type="button" value=" delete "/></a></td>
                            </tr>
                            <tr><td colspan="9"></td></tr>
                            </c:forEach>
                        </table>
                    </fieldset>
                    
                    <br>
                    <br>
                    
                    <fieldset>
                        <legend>Short Term</legend>
                        <table id="table-makati-2" cellpadding="5" cellspacing="5" style="padding: 5px; width: 100%; border-collapse: collapse;">                            
                            <tr>
                                <th>ID</th>
                                <th>Listing ID</th>
                                <th>Start</th>
                                <th>UTC</th>
                                <th>GMT+8</th>
                                <th>End</th>
                                <th>UTC</th>
                                <th>GMT+8</th>
                                <th></th>
                            </tr>
                            <c:forEach items="${model.featuredsManila2}" var="featured">
                            <tr>
                                <td style="width: 150px;">${featured.id}</td>
                                <td style="width: 150px;">${featured.listingID}</td>
                                <td><fmt:formatDate value="${featured.startDate}" pattern="yyyy/MM/dd HH:mm" /></td>
                                <td>${featured.strStartDate}</td>
                                <td>${featured.strStartDateManila}</td>
                                <td><fmt:formatDate value="${featured.endDate}" pattern="yyyy/MM/dd HH:mm" /></td>
                                <td>${featured.strEndDate}</td>
                                <td>${featured.strEndDateManila}</td>
                                <td><a href="${model.props.appPath}/featured.htm?a=9025&id=${featured.id}"><input type="button" value=" delete "/></a></td>
                            </tr>
                            <tr><td colspan="9"></td></tr>
                            </c:forEach>
                        </table>
                    </fieldset>
                    
                    <br><br><br><br>
                    
                    <h2>Featured in Paranaque</h2>
                    <hr style="padding: 5px; background-color: #aaa;">
                    
                    <fieldset>
                        <legend>Long Term</legend>
                        <table id="table-makati-1" cellpadding="5" cellspacing="5" style="padding: 5px; width: 100%; border-collapse: collapse;">                            
                            <tr>
                                <th>ID</th>
                                <th>Listing ID</th>
                                <th>Start</th>
                                <th>UTC</th>
                                <th>GMT+8</th>
                                <th>End</th>
                                <th>UTC</th>
                                <th>GMT+8</th>
                                <th></th>
                            </tr>
                            <c:forEach items="${model.featuredsParanaque1}" var="featured">
                            <tr>
                                <td style="width: 150px;">${featured.id}</td>
                                <td style="width: 150px;">${featured.listingID}</td>
                                <td><fmt:formatDate value="${featured.startDate}" pattern="yyyy/MM/dd HH:mm" /></td>
                                <td>${featured.strStartDate}</td>
                                <td>${featured.strStartDateManila}</td>
                                <td><fmt:formatDate value="${featured.endDate}" pattern="yyyy/MM/dd HH:mm" /></td>
                                <td>${featured.strEndDate}</td>
                                <td>${featured.strEndDateManila}</td>
                                <td><a href="${model.props.appPath}/featured.htm?a=9025&id=${featured.id}"><input type="button" value=" delete "/></a></td>
                            </tr>
                            <tr><td colspan="9"></td></tr>
                            </c:forEach>
                        </table>
                    </fieldset>
                    
                    <br>
                    <br>
                    
                    <fieldset>
                        <legend>Short Term</legend>
                        <table id="table-makati-2" cellpadding="5" cellspacing="5" style="padding: 5px; width: 100%; border-collapse: collapse;">                            
                            <tr>
                                <th>ID</th>
                                <th>Listing ID</th>
                                <th>Start</th>
                                <th>UTC</th>
                                <th>GMT+8</th>
                                <th>End</th>
                                <th>UTC</th>
                                <th>GMT+8</th>
                                <th></th>
                            </tr>
                            <c:forEach items="${model.featuredsParanaque2}" var="featured">
                            <tr>
                                <td style="width: 150px;">${featured.id}</td>
                                <td style="width: 150px;">${featured.listingID}</td>
                                <td><fmt:formatDate value="${featured.startDate}" pattern="yyyy/MM/dd HH:mm" /></td>
                                <td>${featured.strStartDate}</td>
                                <td>${featured.strStartDateManila}</td>
                                <td><fmt:formatDate value="${featured.endDate}" pattern="yyyy/MM/dd HH:mm" /></td>
                                <td>${featured.strEndDate}</td>
                                <td>${featured.strEndDateManila}</td>
                                <td><a href="${model.props.appPath}/featured.htm?a=9025&id=${featured.id}"><input type="button" value=" delete "/></a></td>
                            </tr>
                            <tr><td colspan="9"></td></tr>
                            </c:forEach>
                        </table>
                    </fieldset>
                    
                    <br><br><br><br>
                    
                    <h2>Featured in Muntinlupa</h2>
                    <hr style="padding: 5px; background-color: #aaa;">
                                        
                    <fieldset>
                        <legend>Long Term</legend>
                        <table id="table-makati-1" cellpadding="5" cellspacing="5" style="padding: 5px; width: 100%; border-collapse: collapse;">                            
                            <tr>
                                <th>ID</th>
                                <th>Listing ID</th>
                                <th>Start</th>
                                <th>UTC</th>
                                <th>GMT+8</th>
                                <th>End</th>
                                <th>UTC</th>
                                <th>GMT+8</th>
                                <th></th>
                            </tr>
                            <c:forEach items="${model.featuredsMuntinlupa1}" var="featured">
                            <tr>
                                <td style="width: 150px;">${featured.id}</td>
                                <td style="width: 150px;">${featured.listingID}</td>
                                <td><fmt:formatDate value="${featured.startDate}" pattern="yyyy/MM/dd HH:mm" /></td>
                                <td>${featured.strStartDate}</td>
                                <td>${featured.strStartDateManila}</td>
                                <td><fmt:formatDate value="${featured.endDate}" pattern="yyyy/MM/dd HH:mm" /></td>
                                <td>${featured.strEndDate}</td>
                                <td>${featured.strEndDateManila}</td>
                                <td><a href="${model.props.appPath}/featured.htm?a=9025&id=${featured.id}"><input type="button" value=" delete "/></a></td>
                            </tr>
                            <tr><td colspan="9"></td></tr>
                            </c:forEach>
                        </table>
                    </fieldset>
                    
                    <br>
                    <br>
                    
                    <fieldset>
                        <legend>Short Term</legend>
                        <table id="table-makati-2" cellpadding="5" cellspacing="5" style="padding: 5px; width: 100%; border-collapse: collapse;">                            
                            <tr>
                                <th>ID</th>
                                <th>Listing ID</th>
                                <th>Start</th>
                                <th>UTC</th>
                                <th>GMT+8</th>
                                <th>End</th>
                                <th>UTC</th>
                                <th>GMT+8</th>
                                <th></th>
                            </tr>
                            <c:forEach items="${model.featuredsMuntinlupa2}" var="featured">
                            <tr>
                                <td style="width: 150px;">${featured.id}</td>
                                <td style="width: 150px;">${featured.listingID}</td>
                                <td><fmt:formatDate value="${featured.startDate}" pattern="yyyy/MM/dd HH:mm" /></td>
                                <td>${featured.strStartDate}</td>
                                <td>${featured.strStartDateManila}</td>
                                <td><fmt:formatDate value="${featured.endDate}" pattern="yyyy/MM/dd HH:mm" /></td>
                                <td>${featured.strEndDate}</td>
                                <td>${featured.strEndDateManila}</td>
                                <td><a href="${model.props.appPath}/featured.htm?a=9025&id=${featured.id}"><input type="button" value=" delete "/></a></td>
                            </tr>
                            <tr><td colspan="9"></td></tr>
                            </c:forEach>
                        </table>
                    </fieldset>
                    
                    <br><br><br><br>
                    
                    <h2>Featured in San Juan</h2>
                    <hr style="padding: 5px; background-color: #aaa;">
                                        
                    <fieldset>
                        <legend>Long Term</legend>
                        <table id="table-makati-1" cellpadding="5" cellspacing="5" style="padding: 5px; width: 100%; border-collapse: collapse;">                            
                            <tr>
                                <th>ID</th>
                                <th>Listing ID</th>
                                <th>Start</th>
                                <th>UTC</th>
                                <th>GMT+8</th>
                                <th>End</th>
                                <th>UTC</th>
                                <th>GMT+8</th>
                                <th></th>
                            </tr>
                            <c:forEach items="${model.featuredsSanJuan1}" var="featured">
                            <tr>
                                <td style="width: 150px;">${featured.id}</td>
                                <td style="width: 150px;">${featured.listingID}</td>
                                <td><fmt:formatDate value="${featured.startDate}" pattern="yyyy/MM/dd HH:mm" /></td>
                                <td>${featured.strStartDate}</td>
                                <td>${featured.strStartDateManila}</td>
                                <td><fmt:formatDate value="${featured.endDate}" pattern="yyyy/MM/dd HH:mm" /></td>
                                <td>${featured.strEndDate}</td>
                                <td>${featured.strEndDateManila}</td>
                                <td><a href="${model.props.appPath}/featured.htm?a=9025&id=${featured.id}"><input type="button" value=" delete "/></a></td>
                            </tr>
                            <tr><td colspan="9"></td></tr>
                            </c:forEach>
                        </table>
                    </fieldset>
                    
                    <br>
                    <br>
                    
                    <fieldset>
                        <legend>Short Term</legend>
                        <table id="table-makati-2" cellpadding="5" cellspacing="5" style="padding: 5px; width: 100%; border-collapse: collapse;">                            
                            <tr>
                                <th>ID</th>
                                <th>Listing ID</th>
                                <th>Start</th>
                                <th>UTC</th>
                                <th>GMT+8</th>
                                <th>End</th>
                                <th>UTC</th>
                                <th>GMT+8</th>
                                <th></th>
                            </tr>
                            <c:forEach items="${model.featuredsSanJuan2}" var="featured">
                            <tr>
                                <td style="width: 150px;">${featured.id}</td>
                                <td style="width: 150px;">${featured.listingID}</td>
                                <td><fmt:formatDate value="${featured.startDate}" pattern="yyyy/MM/dd HH:mm" /></td>
                                <td>${featured.strStartDate}</td>
                                <td>${featured.strStartDateManila}</td>
                                <td><fmt:formatDate value="${featured.endDate}" pattern="yyyy/MM/dd HH:mm" /></td>
                                <td>${featured.strEndDate}</td>
                                <td>${featured.strEndDateManila}</td>
                                <td><a href="${model.props.appPath}/featured.htm?a=9025&id=${featured.id}"><input type="button" value=" delete "/></a></td>
                            </tr>
                            <tr><td colspan="9"></td></tr>
                            </c:forEach>
                        </table>
                    </fieldset>
                    
                    <br><br><br><br>
                    
                    <h2>Featured in Cebu</h2>
                    <hr style="padding: 5px; background-color: #aaa;">
                    
                    <fieldset>
                        <legend>Long Term</legend>
                        <table id="table-makati-1" cellpadding="5" cellspacing="5" style="padding: 5px; width: 100%; border-collapse: collapse;">                            
                            <tr>
                                <th>ID</th>
                                <th>Listing ID</th>
                                <th>Start</th>
                                <th>UTC</th>
                                <th>GMT+8</th>
                                <th>End</th>
                                <th>UTC</th>
                                <th>GMT+8</th>
                                <th></th>
                            </tr>
                            <c:forEach items="${model.featuredsCebu1}" var="featured">
                            <tr>
                                <td style="width: 150px;">${featured.id}</td>
                                <td style="width: 150px;">${featured.listingID}</td>
                                <td><fmt:formatDate value="${featured.startDate}" pattern="yyyy/MM/dd HH:mm" /></td>
                                <td>${featured.strStartDate}</td>
                                <td>${featured.strStartDateManila}</td>
                                <td><fmt:formatDate value="${featured.endDate}" pattern="yyyy/MM/dd HH:mm" /></td>
                                <td>${featured.strEndDate}</td>
                                <td>${featured.strEndDateManila}</td>
                                <td><a href="${model.props.appPath}/featured.htm?a=9025&id=${featured.id}"><input type="button" value=" delete "/></a></td>
                            </tr>
                            <tr><td colspan="9"></td></tr>
                            </c:forEach>
                        </table>
                    </fieldset>
                    
                    <br>
                    <br>
                    
                    <fieldset>
                        <legend>Short Term</legend>
                        <table id="table-makati-2" cellpadding="5" cellspacing="5" style="padding: 5px; width: 100%; border-collapse: collapse;">                            
                            <tr>
                                <th>ID</th>
                                <th>Listing ID</th>
                                <th>Start</th>
                                <th>UTC</th>
                                <th>GMT+8</th>
                                <th>End</th>
                                <th>UTC</th>
                                <th>GMT+8</th>
                                <th></th>
                            </tr>
                            <c:forEach items="${model.featuredsCebu2}" var="featured">
                            <tr>
                                <td style="width: 150px;">${featured.id}</td>
                                <td style="width: 150px;">${featured.listingID}</td>
                                <td><fmt:formatDate value="${featured.startDate}" pattern="yyyy/MM/dd HH:mm" /></td>
                                <td>${featured.strStartDate}</td>
                                <td>${featured.strStartDateManila}</td>
                                <td><fmt:formatDate value="${featured.endDate}" pattern="yyyy/MM/dd HH:mm" /></td>
                                <td>${featured.strEndDate}</td>
                                <td>${featured.strEndDateManila}</td>
                                <td><a href="${model.props.appPath}/featured.htm?a=9025&id=${featured.id}"><input type="button" value=" delete "/></a></td>
                            </tr>
                            <tr><td colspan="9"></td></tr>
                            </c:forEach>
                        </table>
                    </fieldset>
                    
                    <br><br><br><br>
                                        
                </div>

                <br><br>                

            </div>

            <div>
                <img src="${model.props.appPath}/img/footer-foot.jpg" style="border: 0px solid black; display: block; width: 100%;" />
            </div>

        </div>

    </body>

</html>
